Articles | Mohamed Said [Skip to content](#main) [ ![](https://cdn.msaied.com/01KT78WE565VEMM3PSNQAAB0MH.png) Mohamed SaidLaravel Backend Engineer ](https://msaied.com) - [Home](https://msaied.com) - [Projects](https://msaied.com/projects) - [Articles](https://msaied.com/articles) - [Certificates](https://msaied.com/certificates) - [About](https://msaied.com#about) [ Contact](https://msaied.com#contact) Menu Menu ---- Close - [HomeStart here](https://msaied.com) - [ProjectsCase studies](https://msaied.com/projects) - [ArticlesEngineering notes](https://msaied.com/articles) - [CertificatesCredentials](https://msaied.com/certificates) - [AboutHow I work](https://msaied.com#about) - [ContactGet in touch](https://msaied.com#contact) [Start a conversation](https://msaied.com#contact) [WhatsApp](https://wa.me/201094619204) [Email](mailto:hello@msaied.com) 1. [Home](https://msaied.com) 2. / 3. Articles Engineering library ==================== 18 articles by Mohamed Said on Laravel, PHP, databases, APIs and infrastructure, written from production work. Search articles ⌕×Search Topic hubs ---------- ←→ - [AI48 articles](https://msaied.com/articles?category=ai&search=mysql&sort=new) - [Composer Pacakge80 articles](https://msaied.com/articles?category=composer-pacakge&search=mysql&sort=new) - [Filament27 articles](https://msaied.com/articles?category=filament&search=mysql&sort=new) - [Laravel266 articles](https://msaied.com/articles?category=laravel&search=mysql&sort=new) - [Livewire13 articles](https://msaied.com/articles?category=livewire&search=mysql&sort=new) - [Open Source44 articles](https://msaied.com/articles?category=open-source&search=mysql&sort=new) - [PHP27 articles](https://msaied.com/articles?category=php&search=mysql&sort=new) - [Tips & Tricks32 articles](https://msaied.com/articles?category=tips-tricks&search=mysql&sort=new) Topics ------ [All topics](https://msaied.com/articles?search=mysql&sort=new) [AI 48](https://msaied.com/articles?category=ai&search=mysql&sort=new) [Composer Pacakge 80](https://msaied.com/articles?category=composer-pacakge&search=mysql&sort=new) [Filament 27](https://msaied.com/articles?category=filament&search=mysql&sort=new) [Laravel 266](https://msaied.com/articles?category=laravel&search=mysql&sort=new) [Livewire 13](https://msaied.com/articles?category=livewire&search=mysql&sort=new) [Open Source 44](https://msaied.com/articles?category=open-source&search=mysql&sort=new) [PHP 27](https://msaied.com/articles?category=php&search=mysql&sort=new) [Tips & Tricks 32](https://msaied.com/articles?category=tips-tricks&search=mysql&sort=new) 18 articles ------------ Topics Sort articles Newest first Oldest first Sort [Search: mysql ×Remove search](https://msaied.com/articles?sort=new) [ Clear filters](https://msaied.com/articles) [![](https://cdn.msaied.com/797/2903a8f469c2bc085780ed09b63d2dd9.png)](https://msaied.com/articles/run-large-planetscale-queries-in-laravel-with-dbolap)19 Oct 2026·4 min read ### [Run Large PlanetScale Queries in Laravel With DB::olap()](https://msaied.com/articles/run-large-planetscale-queries-in-laravel-with-dbolap) Laravel 13.36 adds DB::olap(), a clean way to switch a PlanetScale MySQL connection to Vitess OLAP mode for the duration of a callback, bypassing the 100,000-row and 64 MiB OLTP limits. [Laravel](https://msaied.com/articles?category=laravel) [![](https://cdn.msaied.com/739/2d6897fdcdcf090613f96f72a64b8a78.png)](https://msaied.com/articles/mysql-full-text-search-in-laravel-indexes-relevance-scoring-and-boolean-mode)4 Oct 2026·4 min read ### [MySQL Full-Text Search in Laravel: Indexes, Relevance Scoring, and Boolean Mode](https://msaied.com/articles/mysql-full-text-search-in-laravel-indexes-relevance-scoring-and-boolean-mode) Skip the Elasticsearch overhead for most apps. MySQL full-text indexes with Laravel give you ranked search, boolean operators, and phrase matching — all through Eloquent and raw expressions. [![](https://cdn.msaied.com/723/6f9c9010ccb06581b52bcfab81e47dd9.png)](https://msaied.com/articles/migrating-pinkary-from-laravel-forge-to-laravel-cloud-an-engineering-playbook)30 Sep 2026·5 min read ### [Migrating Pinkary from Laravel Forge to Laravel Cloud: An Engineering Playbook](https://msaied.com/articles/migrating-pinkary-from-laravel-forge-to-laravel-cloud-an-engineering-playbook) A code-backed walkthrough of the real issues encountered moving Pinkary from Laravel Forge to Laravel Cloud: SQLite-to-MySQL schema fixes, nondeterministic query rewrites, object-storage assumptions, and purpose-built Artisan migration commands. [Laravel](https://msaied.com/articles?category=laravel) [![](https://cdn.msaied.com/682/ce36e9a53f64f4683147fdbc73e72caa.png)](https://msaied.com/articles/mysql-explain-and-index-tuning-for-laravel-reading-query-plans-in-production)20 Sep 2026·4 min read ### [MySQL EXPLAIN and Index Tuning for Laravel: Reading Query Plans in Production](https://msaied.com/articles/mysql-explain-and-index-tuning-for-laravel-reading-query-plans-in-production) Stop guessing why your Laravel queries are slow. Learn to read MySQL EXPLAIN output, spot full-table scans, and apply targeted index strategies that actually move the needle in production. [![](https://cdn.msaied.com/600/0c7655400b43d3b85d1d1e9d0f4c8094.png)](https://msaied.com/articles/wherebinary-how-to-run-case-sensitive-mysql-queries-in-laravel-1327)26 Aug 2026·4 min read ### [whereBinary(): How to Run Case-Sensitive MySQL Queries in Laravel 13.27](https://msaied.com/articles/wherebinary-how-to-run-case-sensitive-mysql-queries-in-laravel-1327) Laravel 13.27 adds whereBinary(), orWhereBinary(), whereNotBinary(), and orWhereNotBinary() — clean query-builder methods for byte-exact MySQL comparisons without dropping down to whereRaw(). [Laravel](https://msaied.com/articles?category=laravel) [Tips & Tricks](https://msaied.com/articles?category=tips-tricks) [![](https://cdn.msaied.com/597/bd82bbbaee7d7826a7a3a2f4e8b77330.png)](https://msaied.com/articles/query-binding-masking-and-wherebinary-in-laravel-1327)26 Aug 2026·4 min read ### [Query Binding Masking and whereBinary() in Laravel 13.27](https://msaied.com/articles/query-binding-masking-and-wherebinary-in-laravel-1327) Laravel 13.27 ships query binding masking for safer exception messages, a whereBinary() family for byte-exact MySQL comparisons, refreshForUpdate() for pessimistic locking, a Cloud facade, and queue size totals. [Laravel](https://msaied.com/articles?category=laravel) [![](https://cdn.msaied.com/563/f2d4a7fb0ab45706cf9330746f7b2588.png)](https://msaied.com/articles/mysql-explain-and-query-profiling-in-laravel-finding-slow-queries-before-they-hit-production)18 Aug 2026·3 min read ### [MySQL EXPLAIN and Query Profiling in Laravel: Finding Slow Queries Before They Hit Production](https://msaied.com/articles/mysql-explain-and-query-profiling-in-laravel-finding-slow-queries-before-they-hit-production) Learn how to read MySQL EXPLAIN output, use query profiling tools, and integrate them into a Laravel workflow to catch index misses and full table scans before they reach your users. [![](https://cdn.msaied.com/481/8bfc417cb94b3e2868428e065fe4b166.png)](https://msaied.com/articles/mysql-query-profiling-in-laravel-explain-analyze-slow-query-log-and-index-hints)28 Jul 2026·4 min read ### [MySQL Query Profiling in Laravel: EXPLAIN ANALYZE, Slow Query Log, and Index Hints](https://msaied.com/articles/mysql-query-profiling-in-laravel-explain-analyze-slow-query-log-and-index-hints) Stop guessing why a query is slow. Learn how to use EXPLAIN ANALYZE, Laravel's slow query log listener, and index hints together to find and fix real MySQL bottlenecks in production. [![](https://cdn.msaied.com/439/c2bac2df16b3224f0fe4b871f7f6167f.png)](https://msaied.com/articles/mysql-index-strategies-for-laravel-composite-prefix-and-invisible-indexes-1)18 Jul 2026·4 min read ### [MySQL Index Strategies for Laravel: Composite, Prefix, and Invisible Indexes](https://msaied.com/articles/mysql-index-strategies-for-laravel-composite-prefix-and-invisible-indexes-1) Go beyond single-column indexes. Learn how composite key order, prefix indexes on TEXT columns, and MySQL 8's invisible indexes let you tune Laravel queries without guesswork. ← Newer1. 1 2. [2](https://msaied.com/articles?search=mysql&page=2) 1 / 2 [Older →](https://msaied.com/articles?search=mysql&page=2) Have a technical challenge? ---------------------------- Tell me what you’re building. I reply within two working days. [Discuss your project ↗](https://msaied.com#contact) Topics ------ Close [All topics](https://msaied.com/articles) [AI (48) ](https://msaied.com/articles?category=ai&search=mysql&sort=new) [Composer Pacakge (80) ](https://msaied.com/articles?category=composer-pacakge&search=mysql&sort=new) [Filament (27) ](https://msaied.com/articles?category=filament&search=mysql&sort=new) [Laravel (266) ](https://msaied.com/articles?category=laravel&search=mysql&sort=new) [Livewire (13) ](https://msaied.com/articles?category=livewire&search=mysql&sort=new) [Open Source (44) ](https://msaied.com/articles?category=open-source&search=mysql&sort=new) [PHP (27) ](https://msaied.com/articles?category=php&search=mysql&sort=new) [Tips & Tricks (32) ](https://msaied.com/articles?category=tips-tricks&search=mysql&sort=new) © 2026 Mohamed Said · Built with Laravel, meant to last.Senior Backend Engineer specializing in Laravel, scalable SaaS platforms, APIs, and cloud infrastructure. I build secure, high-performance web applications that help businesses grow. - [Home](https://msaied.com) - [Articles](https://msaied.com/articles) - [Certificates](https://msaied.com/certificates) - [GitHub](https://github.com/EG-Mohamed) - [LinkedIn](https://www.linkedin.com/in/msaiedm/) - [WhatsApp](https://wa.me/201094619204) - [Email Address](mailto:hello@msaied.com) - [My CV](https://drive.google.com/file/u/0/d/1MF20IPRJyzfy32mhEutjL5EpSls0w2Q8/view) - [Sitemap](https://msaied.com/sitemap.xml)